CREATE PROCEDURE spDeletePerson
   @PersonID INT
AS
BEGIN
      DELETE FROM
         tblPersons
      WHERE
         PersonID = @PersonID
END
GO
